/** 病害相关的数据库初始化 */
import {
	TAB_DISEASEGRADE
} from "../config";

/** 初始化等级表 */
export const createDiseaseGradeTable = db => {
	const sql = `
		create table if not exists '${TAB_DISEASEGRADE}'(
			id int primary key,
			_id varchar(255),
			code varchar(255),
			createUserId int,
			createUserName varchar(255),
			diseaseGrade varchar(255),
			diseaseStandardLibraryId varchar(255),
			leaf int,
			recordCreateDate varchar(255),
			recordUpdateDate varchar(255),
			remark varchar(255),
			treeId varchar(255),
			diseaseGradeNo varchar(255),
			treeLevel int	
		);
	`;
	return db.execute(sql);
}
